Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

Results retrieved from a database

This section identifies and briefly defines three coding techniques that Progress 4GL supports to retrieve data source results. In general, you can think of these techniques as handling complex query results for which each technique has its own purpose and benefits.

Using the Progress-supplied proc-text-buffer for row results

This technique allows you to:

Access result sets available through a pseudo table for which each row is a long character string.
Requires you to parse each long string to access specific fields.

The Proc-text-buffer is part of the schema holder, making this result set option independent of the foreign data source.

Defining a special view on the MSS data source to use as a buffer for row results

This technique allows you to:

Define views within the foreign data source.
Use the result set buffer configuration of the view to access the data returned by the stored procedure.

Defining of a special view involves some administration on the foreign datasource and therefore is considered a result set option that is dependent on the foreign data source.